/*
Navicat SQL Server Data Transfer

Source Server         : LOCALHOST
Source Server Version : 110000
Source Host           : .:1433
Source Database       : AAACHAM2
Source Schema         : dbo

Target Server Type    : SQL Server
Target Server Version : 110000
File Encoding         : 65001

Date: 2014-04-25 11:14:41
*/


-- ----------------------------
-- Table structure for tb3014
-- ----------------------------
DROP TABLE [dbo].[tb3014]
GO
CREATE TABLE [dbo].[tb3014] (
[PeriodID] varchar(20) NOT NULL ,
[Description] nvarchar(250) NULL ,
[Notes] nvarchar(150) NULL ,
[Disabled] tinyint NOT NULL DEFAULT ((0)) ,
[IsDistribute] tinyint NOT NULL DEFAULT ((0)) ,
[IsCost] tinyint NOT NULL DEFAULT ((0)) ,
[IsInprocess] tinyint NOT NULL DEFAULT ((0)) ,
[PeriodType] tinyint NOT NULL DEFAULT ((0)) ,
[FromMonth] int NULL ,
[FromYear] int NULL ,
[ToMonth] int NULL ,
[ToYear] int NULL ,
[CreateDate] datetime NULL ,
[CreateUserID] varchar(20) NULL ,
[LastModifyDate] datetime NULL ,
[LastModifyUserID] varchar(20) NULL ,
[DistributionID] varchar(20) NULL ,
[CoefficientID] varchar(20) NULL ,
[InProcessID] varchar(20) NULL ,
[IsFromCost] tinyint NOT NULL DEFAULT ((0)) ,
[IsForPeriodID] tinyint NOT NULL DEFAULT ((0)) ,
[FromPeriodID] varchar(20) NULL ,
[IsDetailCost] tinyint NULL DEFAULT ((0)) 
)


GO

-- ----------------------------
-- Records of tb3014
-- ----------------------------

-- ----------------------------
-- Indexes structure for table tb3014
-- ----------------------------

-- ----------------------------
-- Primary Key structure for table tb3014
-- ----------------------------
ALTER TABLE [dbo].[tb3014] ADD PRIMARY KEY NONCLUSTERED ([PeriodID])
GO
